like a turkey voting for Christmas

Translations
voter pour son propre malheur
Definitions
This phrase is used to describe a situation where someone supports or endorses something that is clearly against their own best interests, often implying a lack of awareness or understanding of the consequences.